Interactive Python: a command shell for interactive computing, originally developed for Python but now also supports other languages
pip install ipythonipython% denotes line magic%% denotes cellular magictimeit%%timeit -n 100
# code goes here%precision 2 - set floating point precision for printing to 2.d.p.%load_ext sql
%sql select * from mytable limit 10Use python variables
value = 42
%sql select * from table where var = :valueAssign results of queries to python variables
result = %sql select * from mytable limit 10
print(result.DataFrame())Import from csv
import pandas as pd
mydata = pd.read_csv('https://....csv')
%sql PERSIST mydata
%sql SELECT * FROM mydata limit 5;